'''
Author: your name
Date: 2021-11-05 17:36:38
LastEditTime: 2021-11-06 21:52:04
LastEditors: Please set LastEditors
Description: 打开koroFileHeader查看配置 进行设置: https://github.com/OBKoro1/koro1FileHeader/wiki/%E9%85%8D%E7%BD%AE
FilePath: /tinyms/tinyms-api/apps/cms/channel/model.py
'''
from app import db
class Channel(db.Model):
    __tablename__ = 'cms_channel'
    channel_pk = db.Column(db.Integer,primary_key=True)
    channel_name = db.Column(db.String)
    channel_parent = db.Column(db.String)
    channel_english = db.Column(db.String)
    channel_path = db.Column(db.String)
    channel_content_template = db.Column(db.String)
    channel_page_template = db.Column(db.String)
    channel_page_count = db.Column(db.String)
    channel_list_template = db.Column(db.String)
    channel_list_count = db.Column(db.String)
    channel_state = db.Column(db.String)


#   `channel_pk` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
#   `channel_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '栏目中文名称',
#   `channel_english` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '栏目英文名称',
#   `channel_parent` varchar(255) DEFAULT NULL COMMENT '父栏目',
#   `channel_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '栏目所在路径',
#   `channel_content_template` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '内容页模板',
#   `channel_page_template` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '分页模板',
#   `channel_page_count` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '每页条数',
#   `channel_list_template` varchar(255) DEFAULT NULL COMMENT '列表页模板',
#   `channel_list_count` varchar(255) DEFAULT NULL COMMENT '列表页数量',
#   `channel_state` varchar(255) DEFAULT NULL COMMENT '栏目状态',